<?php
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP
 *
 * This content is released under the MIT License (MIT)
 *
 * Copyright (c) 2014 - 2017, British Columbia Institute of Technology
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 * THE SOFTWARE.
 *
 * @package	CodeIgniter
 * @author	EllisLab Dev Team
 * @copyright	Copyright (c) 2008 - 2014, EllisLab, Inc. (https://ellislab.com/)
 * @copyright	Copyright (c) 2014 - 2017, British Columbia Institute of Technology (http://bcit.ca/)
 * @license	http://opensource.org/licenses/MIT	MIT License
 * @link	https://codeigniter.com
 * @since	Version 1.0.0
 * @filesource
 */
defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * Model Class
 *
 * @package		CodeIgniter
 * @subpackage	Libraries
 * @category	Libraries
 * @author		EllisLab Dev Team
 * @link		https://codeigniter.com/user_guide/libraries/config.html
 *
 * @property CI_DB_mysqli_driver  db
 *
 */
class CI_Model {

    public $table_name = '';

	/**
	 * Class constructor
	 *
	 * @return	void
	 */
	public function __construct()
	{
		log_message('info', 'Model Class Initialized');
	}

	// --------------------------------------------------------------------

	/**
	 * __get magic
	 *
	 * Allows models to access CI's loaded classes using the same
	 * syntax as controllers.
	 *
	 * @param	string	$key
	 */
	public function __get($key)
	{
		// Debugging note:
		//	If you're here because you're getting an error message
		//	saying 'Undefined Property: system/core/Model.php', it's
		//	most likely a typo in your model code.
		return get_instance()->$key;
	}


    /** 根据筛选条件获取数据
     * @param array $filter
     * @param string $col
     * @param int $start
     * @param int $limit
     * @param string $order_by  例:  'goods_id desc'
     * @param string $group_by  例:  'goods_id'
     * @return array|bool
     */
    public function j_list($filter, $col = '*', $start = 0, $limit = 10000, $order_by = '', $group_by = ''){

	    if(!$this->table_name){
	        return false;
        }
        $this->db->from($this->table_name);

        foreach($filter as $key => $value){
            $this->j_set_where($key, $value);
        }

	    $this->db->select($col)->limit($limit, $start);

        if($order_by){
	        $this->db->order_by($order_by);
        }

	    if($group_by){
	        $this->db->group_by($group_by);
        }

	    $query = $this->db->get();
        $rs = $query->result_array();
        return $rs;
	}


    /** 设置查询条件
     * @param $key
     * @param $value
     * @return CI_DB_mysqli_driver
     */
    public function j_set_where($key, $value){
        if(is_array($value)){
            $this->db->where_in($key, $value);
            goto END;
        }

        list($real_key, $search_type) = explode('|', $key);

        switch($search_type){
            case 'like':
                $this->db->where("{$real_key} like '%{$value}%'");
                break;
            default:
                $this->db->where($key, $value);
                break;
        }

        END:
        return $this->db;
    }



	/** 根据筛选条件获取单条数据
     * @param array $filter
     * @param string $col
     * @return array|bool
     */
    public function j_row($filter, $col = '*'){
	    if(!$this->table_name){
	        return false;
        }
        $this->db->from($this->table_name);

        foreach($filter as $key => $value){
            $this->j_set_where($key, $value);
        }

	    $this->db->select($col);
	    $query = $this->db->get();
        $rs = $query->row_array();

        return $rs;
	}


    /** 根据筛选条件获取总数
     * @param $filter
     * @return int
     */
	public function j_count($filter){

	    if(!$this->table_name){
	        return false;
        }

        $this->db->from($this->table_name);

        foreach($filter as $key => $value){
            $this->j_set_where($key, $value);
        }

        $this->db->select('count(*) as num');
	    $query = $this->db->get();
        $rs = $query->row_array();

        return $rs['num'] ? : 0;

    }

    public function j_insert($data){
	    if(!$this->table_name){
	        return false;
        }

        $this->db->insert($this->table_name, $data);
	    return  $this->db->insert_id();
    }

    public function j_update($data, $where){
	    $table = $this->table_name;
        if(!empty($where)){
            foreach($where as $key => $value){
                $this->j_set_where($key, $value);
            }
        }
        return $this->db->update($table, $data);
    }


}
